Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | StockLedgerAccount(LE_STKACT) |
RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | StockLedgerAccount(LE_STKACT) |
StockLedgerAccountValuationType | A retailer assigned code denoting which valuation method is used to value the Items owned by the MerchandisingRevenueCenter being tracked. Possible values include - Retail Valuation; Last Known Cost Valuation; Average Weighted Cost Valuation, Replacement Cost Valuation. | TY_STKG_VLN | Code2 | char(2) | |
BeginningUnitCount | The number of all Items owned by the MerchandisingCenter at the beginning of the historical ReportingPeriod. | QU_UN_BGN | QuantityTransactionCount | decimal(7,0) | |
CumulativeGrossSalesUnitCount | The cumulative unit sales for a specific ITEM since the beginning of the historical ReportingPeriod, excluding any returns. | QU_SLS_GS_CM | QuantityTransactionCount | decimal(7,0) | |
CumulativeReturnUnitCount | The cumulative number of units returned of a specific ITEM since the beginning of the historical ReportingPeriod. | QU_RTN_CM | QuantityTransactionCount | decimal(7,0) | |
CumulativeReceivedUnitCount | The cumulative number of units received for a particular ITEM since the beginning of the historical ReportingPeriod. | QU_RCV | QuantityTransactionCount | decimal(7,0) | |
CumulativeTransferInUnitCount | The cumulative number of units of a specific ITEM transferred into the RETIL STORE since the beginning of the historical ReportingPeriod. | QU_TSF_IN_CM | QuantityTransactionCount | decimal(7,0) | |
CumulativeTransferOutUnitCount | The cumulative number of units of a specific ITEM transferred out to other RETIL STOREs or other FACILITYs within the retail enterprise since the beginning of the historical ReportingPeriod. | QU_TSF_OT_CM | QuantityTransactionCount | decimal(7,0) | |
CumulativeReturnToVendorUnitCount | The cumulative number of units of a specific ITEM returned to the vendor since the beginning of the historical ReportingPeriod. | QU_RTN_TO_VN | QuantityTransactionCount | decimal(7,0) | |
CumulativeAdjustmentUnitCount | The cumulative adjustment made to the on hand amount of an ITEM since the start of the historical ReportingPeriod. | QU_UN_ADJT_CM | QuantityTransactionCount | decimal(7,0) | |
CurrentUnitCount | The number of all Items owned by the MerchandisingCenter at the end of the historical ReportingPeriod. | QU_UN_CRT | QuantityTransactionCount | decimal(7,0) | |